Skip to main content

Cassandra

Samples Overview

Qarbine provides a wide variety of sample templates, and queries. Some are application oriented examples, while others are database administrator (DBA) oriented.

Below are a few of the component samples to consider. Review the Qarbine Catalog for the latest components. See the latest set of Cassandra components in the folder depicted below.

  

  

Schemas

This general purpose template is at “Qarbine_admin/Cached schemas for prompted data service”. It displays information on all of the cached schemas. These schemas are saved as users interact with data tools such as the Data Source Designer, Query by Example, and Report by Example. If a particular collection is not shown in the output, simply open one of these tools and select it from the collection drop down to create it. Then rerun the template.

Running the template prompts for a data service.

  

Below is a sample snippet from running the template.

  

List Keyspaces

This template is located at “example/Cassandra/DBA/Keyspaces”.

A sample result snippet is shown below.

  

List Table Details in a Keyspace

This template is located at “example/Cassandra/DBA/Table details in a prompted keyspace”.

When run you are prompted to choose a keyspace.

  

Select one and then click

  

Sample results are shown below.

  

The table details are based on the answer set from the data source at “example/Cassandra/DBA/Tables in a prompted keyspace”. That data source references the Qarbine prompt.

Describe a Table in a Keyspace

This template is located at “example/Cassandra/DBA/Describe a prompted table”.

Running it first presents a prompt. The keyspaces are listed.

  

Choose a keyspace

  

The tables are listed. Choose a table

  

Click

  

A sample result is shown below.

  

The information is based on the Cassandra metadata and does not expand on the details of the address column. For this reason the schema output mentioned above may be more useful depending on the situation.

The index details are based on the answer set from the data source at “example/Cassandra/DBA/Describe a prompted table”. That data source references the Qarbine prompt.

List Index of a Table in a Keyspace

This template is located at “example/Cassandra/DBA/Indexes for a prompted table”.

Running it first presents a prompt. The keyspaces are listed.

  

Choose a keyspace

  

The tables are listed. Choose a table

  

Click

  

A sample result is shown below.

  

The index details are based on the answer set from the data source at “example/Cassandra/DBA/Indexes for a prompted table”. That data source references the Qarbine prompt.